USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[AssistsInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.AssistsInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Assists Table Insert
-- =============================================
CREATE PROCEDURE AssistsInsert

	@AssistId int,
	@AssistTime datetime,
	@KillId int,
	@Assister_playerId varchar(30),
	@Victim_playerId varchar(30),
	@Attacker_position_x float,
	@Attacker_position_y float,
	@Attacker_position_z float,
	@Assister_position_x float,
	@Assister_position_y float,
	@Assister_position_z float,
	@Victim_position_x float,
	@Victim_position_y float,
	@Victim_position_z float,
	@LogId int,
	@RoundId int,
	@MiniRoundId int,
	@MapId int,
	@ClassId int,
	@AssistType varchar(30)
	

AS
BEGIN

	INSERT INTO [Assists] (AssistId, AssistTime, KillId, Assister_playerId, Victim_playerId, 
			Attacker_position_x, Attacker_position_y, Attacker_position_z,
			Assister_position_x, Assister_position_y, Assister_position_z,
			Victim_position_x, Victim_position_y, Victim_position_z, LogId,
			RoundId, MiniRoundId, MapId, ClassId, AssistType)
	VALUES
		(@AssistId, @AssistTime, @KillId, @Assister_playerId, @Victim_playerId, 
			@Attacker_position_x, @Attacker_position_y, @Attacker_position_z,
			@Assister_position_x, @Assister_position_y, @Assister_position_z,			
			@Victim_position_x, @Victim_position_y, @Victim_position_z, @LogId,
			@RoundId, @MiniRoundId, @MapId, @ClassId, @AssistType)

END
GO
